// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_PROD_WO
// * CreateDate    : 2014-06-05 18:30:22
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:22
// * LastChanger   : 2014-06-05 18:30:22
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class ProdWoTable : TableInfo
    {
		public const string C_TableName = "PROD_WO";
		
		public const string C_ID = "ID";
		public const string C_IS_ACTIVE = "IS_ACTIVE";
		public const string C_CREATED_BY = "CREATED_BY";
		public const string C_CREATED_DATE = "CREATED_DATE";
		public const string C_UPDATED_BY = "UPDATED_BY";
		public const string C_UPDATED_DATE = "UPDATED_DATE";
		public const string C_PO_ID = "PO_ID";
		public const string C_BOM_ITEM_ID = "BOM_ITEM_ID";
		public const string C_BOM_TECHNIC_ID = "BOM_TECHNIC_ID";
		public const string C_PRODUCT_ID = "PRODUCT_ID";
		public const string C_PRODUCT_NAME = "PRODUCT_NAME";
		public const string C_PRODUCT_CODE = "PRODUCT_CODE";
		public const string C_BLUEPRINT_ID = "BLUEPRINT_ID";
		public const string C_WO_NO = "WO_NO";
		public const string C_QTY = "QTY";
		public const string C_UNIT = "UNIT";
		public const string C_STORAGE_QTY = "STORAGE_QTY";
		public const string C_SCRAP_QTY = "SCRAP_QTY";
		public const string C_TYPE = "TYPE";
		public const string C_REQ_DATE = "REQ_DATE";
		public const string C_PARENT_WO_NO = "PARENT_WO_NO";
		public const string C_FINISH_DATE = "FINISH_DATE";
		public const string C_STATUS = "STATUS";
		public const string C_PLAN_START_DATE = "PLAN_START_DATE";
		public const string C_START_DATE = "START_DATE";
		
		public ProdWoTable()
        {
            _tableName = "PROD_WO";
        }
		
		protected static ProdWoTable _current;
        public static ProdWoTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new ProdWoTable();

            _current.Add(C_ID, new ColumnInfo(C_ID,"Id", true, typeof(string)));
            _current.Add(C_IS_ACTIVE, new ColumnInfo(C_IS_ACTIVE,"IsActive", false, typeof(int)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY,"CreatedBy", false, typeof(string)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE,"CreatedDate", false, typeof(DateTime)));
            _current.Add(C_UPDATED_BY, new ColumnInfo(C_UPDATED_BY,"UpdatedBy", false, typeof(string)));
            _current.Add(C_UPDATED_DATE, new ColumnInfo(C_UPDATED_DATE,"UpdatedDate", false, typeof(DateTime)));
            _current.Add(C_PO_ID, new ColumnInfo(C_PO_ID,"PoId", false, typeof(string)));
            _current.Add(C_BOM_ITEM_ID, new ColumnInfo(C_BOM_ITEM_ID,"BomItemId", false, typeof(string)));
            _current.Add(C_BOM_TECHNIC_ID, new ColumnInfo(C_BOM_TECHNIC_ID,"BomTechnicId", false, typeof(string)));
            _current.Add(C_PRODUCT_ID, new ColumnInfo(C_PRODUCT_ID,"ProductId", false, typeof(string)));
            _current.Add(C_PRODUCT_NAME, new ColumnInfo(C_PRODUCT_NAME,"ProductName", false, typeof(string)));
            _current.Add(C_PRODUCT_CODE, new ColumnInfo(C_PRODUCT_CODE,"ProductCode", false, typeof(string)));
            _current.Add(C_BLUEPRINT_ID, new ColumnInfo(C_BLUEPRINT_ID,"BlueprintId", false, typeof(string)));
            _current.Add(C_WO_NO, new ColumnInfo(C_WO_NO,"WoNo", false, typeof(string)));
            _current.Add(C_QTY, new ColumnInfo(C_QTY,"Qty", false, typeof(decimal)));
            _current.Add(C_UNIT, new ColumnInfo(C_UNIT,"Unit", false, typeof(string)));
            _current.Add(C_STORAGE_QTY, new ColumnInfo(C_STORAGE_QTY,"StorageQty", false, typeof(decimal)));
            _current.Add(C_SCRAP_QTY, new ColumnInfo(C_SCRAP_QTY,"ScrapQty", false, typeof(decimal)));
            _current.Add(C_TYPE, new ColumnInfo(C_TYPE,"Type", false, typeof(string)));
            _current.Add(C_REQ_DATE, new ColumnInfo(C_REQ_DATE,"ReqDate", false, typeof(DateTime)));
            _current.Add(C_PARENT_WO_NO, new ColumnInfo(C_PARENT_WO_NO,"ParentWoNo", false, typeof(string)));
            _current.Add(C_FINISH_DATE, new ColumnInfo(C_FINISH_DATE,"FinishDate", false, typeof(DateTime)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS,"Status", false, typeof(string)));
            _current.Add(C_PLAN_START_DATE, new ColumnInfo(C_PLAN_START_DATE,"PlanStartDate", false, typeof(DateTime)));
            _current.Add(C_START_DATE, new ColumnInfo(C_START_DATE,"StartDate", false, typeof(DateTime)));
			
		}
		
		public ColumnInfo ID
        {
            get { return this[C_ID]; }
        }
		
		public ColumnInfo IS_ACTIVE
        {
            get { return this[C_IS_ACTIVE]; }
        }
		
		public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }
		
		public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }
		
		public ColumnInfo UPDATED_BY
        {
            get { return this[C_UPDATED_BY]; }
        }
		
		public ColumnInfo UPDATED_DATE
        {
            get { return this[C_UPDATED_DATE]; }
        }
		
		public ColumnInfo PO_ID
        {
            get { return this[C_PO_ID]; }
        }
		
		public ColumnInfo BOM_ITEM_ID
        {
            get { return this[C_BOM_ITEM_ID]; }
        }
		
		public ColumnInfo BOM_TECHNIC_ID
        {
            get { return this[C_BOM_TECHNIC_ID]; }
        }
		
		public ColumnInfo PRODUCT_ID
        {
            get { return this[C_PRODUCT_ID]; }
        }
		
		public ColumnInfo PRODUCT_NAME
        {
            get { return this[C_PRODUCT_NAME]; }
        }
		
		public ColumnInfo PRODUCT_CODE
        {
            get { return this[C_PRODUCT_CODE]; }
        }
		
		public ColumnInfo BLUEPRINT_ID
        {
            get { return this[C_BLUEPRINT_ID]; }
        }
		
		public ColumnInfo WO_NO
        {
            get { return this[C_WO_NO]; }
        }
		
		public ColumnInfo QTY
        {
            get { return this[C_QTY]; }
        }
		
		public ColumnInfo UNIT
        {
            get { return this[C_UNIT]; }
        }
		
		public ColumnInfo STORAGE_QTY
        {
            get { return this[C_STORAGE_QTY]; }
        }
		
		public ColumnInfo SCRAP_QTY
        {
            get { return this[C_SCRAP_QTY]; }
        }
		
		public ColumnInfo TYPE
        {
            get { return this[C_TYPE]; }
        }
		
		public ColumnInfo REQ_DATE
        {
            get { return this[C_REQ_DATE]; }
        }
		
		public ColumnInfo PARENT_WO_NO
        {
            get { return this[C_PARENT_WO_NO]; }
        }
		
		public ColumnInfo FINISH_DATE
        {
            get { return this[C_FINISH_DATE]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }
		
		public ColumnInfo PLAN_START_DATE
        {
            get { return this[C_PLAN_START_DATE]; }
        }
		
		public ColumnInfo START_DATE
        {
            get { return this[C_START_DATE]; }
        }
		
		
		
	}
}

